USE [ZwmsDB]
GO

/****** Object:  Table [dbo].[Sys_OptLog]    Script Date: 09/21/2011 23:30:06 ******/


SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

drop table [dbo].[Sys_OptLog]
go

CREATE TABLE [dbo].[Sys_OptLog](
	[UserCode] [nchar](10) NOT NULL,
	[LogNo] [nchar](10) NOT NULL,
	[ObjectClass] [nchar](20) NOT NULL,
	[ObjectID] [nchar](20) NOT NULL,
	[OptKind] [nchar](1) NOT NULL,
	[OptDate] [nchar](8) NOT NULL,
	[OptTime] [nchar](6) NOT NULL,
	[Remark] [nchar](20) NOT NULL,
 CONSTRAINT [PK_Sys_OptLog] PRIMARY KEY CLUSTERED 
(
	[LogNo] ASC,
	[OptDate] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO


